Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 17773 |
| Missing cells | 33252 |
| Missing cells (%) | 13.4% |
| Duplicate rows | 38 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 149.7 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 1 |
| Dataset has 38 (0.2%) duplicate rows | Duplicates |
Minimum Temperature is highly overall correlated with Maximum Temperature and 5 other fields | High correlation |
Maximum Temperature is highly overall correlated with Minimum Temperature and 5 other fields | High correlation |
Temperature is highly overall correlated with Minimum Temperature and 5 other fields | High correlation |
Dew Point is highly overall correlated with Minimum Temperature and 4 other fields | High correlation |
Relative Humidity is highly overall correlated with Minimum Temperature and 3 other fields | High correlation |
Wind Chill is highly overall correlated with Minimum Temperature and 4 other fields | High correlation |
Snow Depth is highly overall correlated with Minimum Temperature and 5 other fields | High correlation |
Visibility is highly overall correlated with Relative Humidity | High correlation |
Sea Level Pressure is highly overall correlated with Snow Depth | High correlation |
Wind Chill has 10051 (56.6%) missing values | Missing |
Snow Depth has 6781 (38.2%) missing values | Missing |
Visibility has 1384 (7.8%) missing values | Missing |
Cloud Cover has 14193 (79.9%) missing values | Missing |
Precipitation has 13849 (77.9%) zeros | Zeros |
Snow Depth has 9943 (55.9%) zeros | Zeros |
y has 8059 (45.3%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-18 19:55:18.566615 |
|---|---|
| Analysis finished | 2022-12-18 19:55:35.963550 |
| Duration | 17.4 seconds |
| Software version | pandas-profiling vv3.5.0 |
| Download configuration | config.json |
Minimum Temperature
Real number (ℝ)
| Distinct | 446 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 48 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.393817 |
| Minimum | -13.2 |
|---|---|
| Maximum | 38.2 |
| Zeros | 26 |
| Zeros (%) | 0.1% |
| Negative | 853 |
| Negative (%) | 4.8% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -13.2 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 4.9 |
| median | 10 |
| Q3 | 15.6 |
| 95-th percentile | 22.5 |
| Maximum | 38.2 |
| Range | 51.4 |
| Interquartile range (IQR) | 10.7 |
Descriptive statistics
| Standard deviation | 7.1329548 |
|---|---|
| Coefficient of variation (CV) | 0.68626906 |
| Kurtosis | -0.24037381 |
| Mean | 10.393817 |
| Median Absolute Deviation (MAD) | 5.3 |
| Skewness | 0.21849668 |
| Sum | 184230.4 |
| Variance | 50.879044 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.1 | 113 | 0.6% |
| 6.4 | 107 | 0.6% |
| 3.1 | 106 | 0.6% |
| 9.1 | 106 | 0.6% |
| 11.9 | 105 | 0.6% |
| 9.2 | 104 | 0.6% |
| 8.4 | 104 | 0.6% |
| 9.6 | 101 | 0.6% |
| 8 | 100 | 0.6% |
| 13.4 | 100 | 0.6% |
| Other values (436) | 16679 |
| Value | Count | Frequency (%) |
| -13.2 | 1 | |
| -12.8 | 2 | |
| -12.5 | 1 | |
| -12.4 | 1 | |
| -12.1 | 1 | |
| -11.7 | 1 | |
| -11.6 | 2 | |
| -11.4 | 1 | |
| -11.3 | 1 | |
| -11.2 | 1 |
| Value | Count | Frequency (%) |
| 38.2 | 1 | |
| 37.9 | 1 | |
| 37.1 | 1 | |
| 35.3 | 1 | |
| 35.1 | 1 | |
| 34.9 | 1 | |
| 34.5 | 1 | |
| 34 | 2 | |
| 33.9 | 1 | |
| 33.7 | 2 |
Maximum Temperature
Real number (ℝ)
| Distinct | 446 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 48 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.393817 |
| Minimum | -13.2 |
|---|---|
| Maximum | 38.2 |
| Zeros | 26 |
| Zeros (%) | 0.1% |
| Negative | 853 |
| Negative (%) | 4.8% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -13.2 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 4.9 |
| median | 10 |
| Q3 | 15.6 |
| 95-th percentile | 22.5 |
| Maximum | 38.2 |
| Range | 51.4 |
| Interquartile range (IQR) | 10.7 |
Descriptive statistics
| Standard deviation | 7.1329548 |
|---|---|
| Coefficient of variation (CV) | 0.68626906 |
| Kurtosis | -0.24037381 |
| Mean | 10.393817 |
| Median Absolute Deviation (MAD) | 5.3 |
| Skewness | 0.21849668 |
| Sum | 184230.4 |
| Variance | 50.879044 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.1 | 113 | 0.6% |
| 6.4 | 107 | 0.6% |
| 3.1 | 106 | 0.6% |
| 9.1 | 106 | 0.6% |
| 11.9 | 105 | 0.6% |
| 9.2 | 104 | 0.6% |
| 8.4 | 104 | 0.6% |
| 9.6 | 101 | 0.6% |
| 8 | 100 | 0.6% |
| 13.4 | 100 | 0.6% |
| Other values (436) | 16679 |
| Value | Count | Frequency (%) |
| -13.2 | 1 | |
| -12.8 | 2 | |
| -12.5 | 1 | |
| -12.4 | 1 | |
| -12.1 | 1 | |
| -11.7 | 1 | |
| -11.6 | 2 | |
| -11.4 | 1 | |
| -11.3 | 1 | |
| -11.2 | 1 |
| Value | Count | Frequency (%) |
| 38.2 | 1 | |
| 37.9 | 1 | |
| 37.1 | 1 | |
| 35.3 | 1 | |
| 35.1 | 1 | |
| 34.9 | 1 | |
| 34.5 | 1 | |
| 34 | 2 | |
| 33.9 | 1 | |
| 33.7 | 2 |
Temperature
Real number (ℝ)
| Distinct | 446 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 48 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.393817 |
| Minimum | -13.2 |
|---|---|
| Maximum | 38.2 |
| Zeros | 26 |
| Zeros (%) | 0.1% |
| Negative | 853 |
| Negative (%) | 4.8% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -13.2 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 4.9 |
| median | 10 |
| Q3 | 15.6 |
| 95-th percentile | 22.5 |
| Maximum | 38.2 |
| Range | 51.4 |
| Interquartile range (IQR) | 10.7 |
Descriptive statistics
| Standard deviation | 7.1329548 |
|---|---|
| Coefficient of variation (CV) | 0.68626906 |
| Kurtosis | -0.24037381 |
| Mean | 10.393817 |
| Median Absolute Deviation (MAD) | 5.3 |
| Skewness | 0.21849668 |
| Sum | 184230.4 |
| Variance | 50.879044 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.1 | 113 | 0.6% |
| 6.4 | 107 | 0.6% |
| 3.1 | 106 | 0.6% |
| 9.1 | 106 | 0.6% |
| 11.9 | 105 | 0.6% |
| 9.2 | 104 | 0.6% |
| 8.4 | 104 | 0.6% |
| 9.6 | 101 | 0.6% |
| 8 | 100 | 0.6% |
| 13.4 | 100 | 0.6% |
| Other values (436) | 16679 |
| Value | Count | Frequency (%) |
| -13.2 | 1 | |
| -12.8 | 2 | |
| -12.5 | 1 | |
| -12.4 | 1 | |
| -12.1 | 1 | |
| -11.7 | 1 | |
| -11.6 | 2 | |
| -11.4 | 1 | |
| -11.3 | 1 | |
| -11.2 | 1 |
| Value | Count | Frequency (%) |
| 38.2 | 1 | |
| 37.9 | 1 | |
| 37.1 | 1 | |
| 35.3 | 1 | |
| 35.1 | 1 | |
| 34.9 | 1 | |
| 34.5 | 1 | |
| 34 | 2 | |
| 33.9 | 1 | |
| 33.7 | 2 |
Dew Point
Real number (ℝ)
| Distinct | 345 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 120 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4477029 |
| Minimum | -14.6 |
|---|---|
| Maximum | 21 |
| Zeros | 112 |
| Zeros (%) | 0.6% |
| Negative | 2335 |
| Negative (%) | 13.1% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -14.6 |
|---|---|
| 5-th percentile | -3.5 |
| Q1 | 2.1 |
| median | 6.8 |
| Q3 | 10.9 |
| 95-th percentile | 15.7 |
| Maximum | 21 |
| Range | 35.6 |
| Interquartile range (IQR) | 8.8 |
Descriptive statistics
| Standard deviation | 6.0195496 |
|---|---|
| Coefficient of variation (CV) | 0.93359599 |
| Kurtosis | -0.24269251 |
| Mean | 6.4477029 |
| Median Absolute Deviation (MAD) | 4.5 |
| Skewness | -0.29686343 |
| Sum | 113821.3 |
| Variance | 36.234977 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 139 | 0.8% |
| 1.6 | 128 | 0.7% |
| 9.5 | 126 | 0.7% |
| 2.8 | 125 | 0.7% |
| 10 | 122 | 0.7% |
| 8.2 | 119 | 0.7% |
| 9.8 | 118 | 0.7% |
| 9.6 | 117 | 0.7% |
| 8.9 | 115 | 0.6% |
| 9.7 | 115 | 0.6% |
| Other values (335) | 16429 | |
| (Missing) | 120 | 0.7% |
| Value | Count | Frequency (%) |
| -14.6 | 1 | < 0.1% |
| -14.1 | 1 | < 0.1% |
| -14 | 1 | < 0.1% |
| -13.9 | 2 | < 0.1% |
| -13.8 | 1 | < 0.1% |
| -13.5 | 1 | < 0.1% |
| -13.3 | 2 | < 0.1% |
| -13.2 | 2 | < 0.1% |
| -13.1 | 1 | < 0.1% |
| -12.9 | 6 |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20.9 | 1 | < 0.1% |
| 20.8 | 1 | < 0.1% |
| 20.6 | 1 | < 0.1% |
| 20.4 | 2 | < 0.1% |
| 20.2 | 5 | |
| 20.1 | 2 | < 0.1% |
| 20 | 3 | |
| 19.9 | 1 | < 0.1% |
| 19.8 | 3 |
Relative Humidity
Real number (ℝ)
| Distinct | 5424 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 120 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 78.605042 |
| Minimum | 18.7 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 18.7 |
|---|---|
| 5-th percentile | 46.47 |
| Q1 | 68.64 |
| median | 82.93 |
| Q3 | 91.59 |
| 95-th percentile | 97.12 |
| Maximum | 100 |
| Range | 81.3 |
| Interquartile range (IQR) | 22.95 |
Descriptive statistics
| Standard deviation | 16.060288 |
|---|---|
| Coefficient of variation (CV) | 0.20431626 |
| Kurtosis | 0.032139079 |
| Mean | 78.605042 |
| Median Absolute Deviation (MAD) | 10.19 |
| Skewness | -0.90235993 |
| Sum | 1387614.8 |
| Variance | 257.93284 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 93.91 | 16 | 0.1% |
| 93.1 | 15 | 0.1% |
| 92.78 | 15 | 0.1% |
| 94.59 | 15 | 0.1% |
| 95.12 | 14 | 0.1% |
| 93.46 | 13 | 0.1% |
| 91.87 | 13 | 0.1% |
| 94.89 | 13 | 0.1% |
| 93.57 | 13 | 0.1% |
| 95.62 | 13 | 0.1% |
| Other values (5414) | 17513 | |
| (Missing) | 120 | 0.7% |
| Value | Count | Frequency (%) |
| 18.7 | 1 | |
| 19.35 | 1 | |
| 21.9 | 1 | |
| 21.99 | 1 | |
| 22.38 | 1 | |
| 23.31 | 1 | |
| 23.41 | 1 | |
| 24.26 | 1 | |
| 24.27 | 1 | |
| 25.33 | 1 |
| Value | Count | Frequency (%) |
| 100 | 12 | |
| 99.97 | 6 | |
| 99.96 | 2 | < 0.1% |
| 99.95 | 2 | < 0.1% |
| 99.93 | 2 | < 0.1% |
| 99.92 | 1 | < 0.1% |
| 99.89 | 3 | < 0.1% |
| 99.88 | 1 | < 0.1% |
| 99.87 | 1 | < 0.1% |
| 99.85 | 1 | < 0.1% |
Wind Speed
Real number (ℝ)
| Distinct | 453 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 145 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.894424 |
| Minimum | 0.1 |
|---|---|
| Maximum | 55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8.2 |
| median | 12.8 |
| Q3 | 18.4 |
| 95-th percentile | 28.6 |
| Maximum | 55 |
| Range | 54.9 |
| Interquartile range (IQR) | 10.2 |
Descriptive statistics
| Standard deviation | 7.8205459 |
|---|---|
| Coefficient of variation (CV) | 0.56285501 |
| Kurtosis | 0.91121169 |
| Mean | 13.894424 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.83418643 |
| Sum | 244930.9 |
| Variance | 61.160938 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.6 | 119 | 0.7% |
| 14.4 | 115 | 0.6% |
| 13.2 | 114 | 0.6% |
| 13.6 | 113 | 0.6% |
| 11.9 | 112 | 0.6% |
| 11.6 | 112 | 0.6% |
| 11.8 | 111 | 0.6% |
| 10.4 | 110 | 0.6% |
| 11.2 | 110 | 0.6% |
| 13.8 | 110 | 0.6% |
| Other values (443) | 16502 | |
| (Missing) | 145 | 0.8% |
| Value | Count | Frequency (%) |
| 0.1 | 3 | < 0.1% |
| 0.2 | 9 | |
| 0.3 | 2 | < 0.1% |
| 0.4 | 12 | |
| 0.5 | 13 | |
| 0.6 | 8 | |
| 0.7 | 8 | |
| 0.8 | 13 | |
| 0.9 | 8 | |
| 1 | 14 |
| Value | Count | Frequency (%) |
| 55 | 1 | |
| 53.9 | 1 | |
| 53.3 | 1 | |
| 53 | 2 | |
| 52.9 | 2 | |
| 51.2 | 1 | |
| 50.2 | 1 | |
| 50.1 | 1 | |
| 50 | 1 | |
| 49.2 | 1 |
Wind Direction
Real number (ℝ)
| Distinct | 353 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 145 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.2213 |
| Minimum | 1 |
|---|---|
| Maximum | 360 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 44 |
| Q1 | 131 |
| median | 224 |
| Q3 | 279 |
| 95-th percentile | 324 |
| Maximum | 360 |
| Range | 359 |
| Interquartile range (IQR) | 148 |
Descriptive statistics
| Standard deviation | 90.198712 |
|---|---|
| Coefficient of variation (CV) | 0.44384478 |
| Kurtosis | -0.90615066 |
| Mean | 203.2213 |
| Median Absolute Deviation (MAD) | 67 |
| Skewness | -0.44029223 |
| Sum | 3582385 |
| Variance | 8135.8077 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 230 | 347 | 2.0% |
| 229 | 342 | 1.9% |
| 290 | 314 | 1.8% |
| 220 | 313 | 1.8% |
| 239 | 284 | 1.6% |
| 250 | 267 | 1.5% |
| 300 | 252 | 1.4% |
| 240 | 226 | 1.3% |
| 260 | 225 | 1.3% |
| 219 | 219 | 1.2% |
| Other values (343) | 14839 |
| Value | Count | Frequency (%) |
| 1 | 19 | |
| 2 | 4 | < 0.1% |
| 3 | 21 | |
| 4 | 20 | |
| 5 | 6 | < 0.1% |
| 6 | 18 | |
| 7 | 22 | |
| 8 | 4 | < 0.1% |
| 9 | 21 | |
| 10 | 34 |
| Value | Count | Frequency (%) |
| 360 | 32 | |
| 359 | 22 | |
| 357 | 13 | 0.1% |
| 356 | 16 | |
| 355 | 14 | 0.1% |
| 354 | 7 | < 0.1% |
| 353 | 26 | |
| 352 | 5 | < 0.1% |
| 351 | 23 | |
| 350 | 35 |
| Distinct | 237 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 10051 |
| Missing (%) | 56.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6888889 |
| Minimum | -15.5 |
|---|---|
| Maximum | 9.7 |
| Zeros | 44 |
| Zeros (%) | 0.2% |
| Negative | 2492 |
| Negative (%) | 14.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -15.5 |
|---|---|
| 5-th percentile | -5.1 |
| Q1 | -1.1 |
| median | 1.9 |
| Q3 | 4.9 |
| 95-th percentile | 7.5 |
| Maximum | 9.7 |
| Range | 25.2 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.123516 |
|---|---|
| Coefficient of variation (CV) | 2.4415555 |
| Kurtosis | 0.48745001 |
| Mean | 1.6888889 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.61871089 |
| Sum | 13041.6 |
| Variance | 17.003384 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.2 | 86 | 0.5% |
| 2.1 | 85 | 0.5% |
| 0.8 | 85 | 0.5% |
| 1.4 | 85 | 0.5% |
| 2 | 81 | 0.5% |
| 3.5 | 79 | 0.4% |
| 1.9 | 79 | 0.4% |
| 1 | 78 | 0.4% |
| -2.3 | 76 | 0.4% |
| 6.7 | 74 | 0.4% |
| Other values (227) | 6914 | |
| (Missing) | 10051 |
| Value | Count | Frequency (%) |
| -15.5 | 1 | |
| -15.1 | 1 | |
| -15 | 1 | |
| -14.9 | 1 | |
| -14.4 | 2 | |
| -14.2 | 1 | |
| -14 | 1 | |
| -13.9 | 1 | |
| -13.7 | 1 | |
| -13.5 | 1 |
| Value | Count | Frequency (%) |
| 9.7 | 1 | < 0.1% |
| 9.5 | 1 | < 0.1% |
| 9.3 | 2 | < 0.1% |
| 9.2 | 5 | < 0.1% |
| 9.1 | 8 | |
| 9 | 7 | |
| 8.9 | 11 | |
| 8.8 | 15 | |
| 8.7 | 11 | |
| 8.6 | 15 |
Precipitation
Real number (ℝ)
| Distinct | 298 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.083767513 |
| Minimum | 0 |
|---|---|
| Maximum | 9.02 |
| Zeros | 13849 |
| Zeros (%) | 77.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.47 |
| Maximum | 9.02 |
| Range | 9.02 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.35540161 |
|---|---|
| Coefficient of variation (CV) | 4.2427141 |
| Kurtosis | 104.28442 |
| Mean | 0.083767513 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.36545 |
| Sum | 1488.8 |
| Variance | 0.1263103 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 13849 | |
| 0.01 | 602 | 3.4% |
| 0.02 | 270 | 1.5% |
| 0.05 | 197 | 1.1% |
| 0.03 | 194 | 1.1% |
| 0.04 | 143 | 0.8% |
| 0.06 | 122 | 0.7% |
| 0.08 | 105 | 0.6% |
| 0.07 | 94 | 0.5% |
| 0.09 | 79 | 0.4% |
| Other values (288) | 2118 | 11.9% |
| Value | Count | Frequency (%) |
| 0 | 13849 | |
| 0.01 | 602 | 3.4% |
| 0.02 | 270 | 1.5% |
| 0.03 | 194 | 1.1% |
| 0.04 | 143 | 0.8% |
| 0.05 | 197 | 1.1% |
| 0.06 | 122 | 0.7% |
| 0.07 | 94 | 0.5% |
| 0.08 | 105 | 0.6% |
| 0.09 | 79 | 0.4% |
| Value | Count | Frequency (%) |
| 9.02 | 1 | |
| 7.87 | 1 | |
| 7.54 | 1 | |
| 5.77 | 1 | |
| 5.73 | 1 | |
| 5.3 | 1 | |
| 5.18 | 1 | |
| 5.01 | 1 | |
| 4.99 | 1 | |
| 4.96 | 1 |
| Distinct | 378 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 6781 |
| Missing (%) | 38.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17686226 |
| Minimum | 0 |
|---|---|
| Maximum | 6.37 |
| Zeros | 9943 |
| Zeros (%) | 55.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 6.37 |
| Range | 6.37 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.72921681 |
|---|---|
| Coefficient of variation (CV) | 4.1230774 |
| Kurtosis | 28.565441 |
| Mean | 0.17686226 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1128458 |
| Sum | 1944.07 |
| Variance | 0.53175715 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9943 | |
| 3 | 52 | 0.3% |
| 2 | 50 | 0.3% |
| 1 | 35 | 0.2% |
| 0.54 | 18 | 0.1% |
| 0.25 | 17 | 0.1% |
| 0.33 | 17 | 0.1% |
| 0.83 | 17 | 0.1% |
| 0.79 | 17 | 0.1% |
| 0.67 | 17 | 0.1% |
| Other values (368) | 809 | 4.6% |
| (Missing) | 6781 |
| Value | Count | Frequency (%) |
| 0 | 9943 | |
| 0.04 | 14 | 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 15 | 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 2 | < 0.1% |
| 0.13 | 14 | 0.1% |
| 0.15 | 3 | < 0.1% |
| 0.17 | 15 | 0.1% |
| 0.18 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 6.37 | 1 | |
| 6.35 | 1 | |
| 6.33 | 1 | |
| 6.3 | 1 | |
| 6.28 | 2 | |
| 6.26 | 1 | |
| 6.24 | 1 | |
| 6.22 | 1 | |
| 6.2 | 1 | |
| 6.18 | 1 |
| Distinct | 481 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 1384 |
| Missing (%) | 7.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.009323 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 103 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.6 |
| Q1 | 13.5 |
| median | 28.5 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 26.5 |
Descriptive statistics
| Standard deviation | 14.738858 |
|---|---|
| Coefficient of variation (CV) | 0.5456952 |
| Kurtosis | -1.2637 |
| Mean | 27.009323 |
| Median Absolute Deviation (MAD) | 12.5 |
| Skewness | -0.11118611 |
| Sum | 442655.8 |
| Variance | 217.23394 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 821 | 4.6% |
| 40 | 698 | 3.9% |
| 45 | 616 | 3.5% |
| 30 | 173 | 1.0% |
| 35 | 165 | 0.9% |
| 41 | 125 | 0.7% |
| 5 | 111 | 0.6% |
| 25 | 105 | 0.6% |
| 0 | 103 | 0.6% |
| 40.7 | 98 | 0.6% |
| Other values (471) | 13374 | |
| (Missing) | 1384 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 103 | |
| 0.1 | 13 | 0.1% |
| 0.3 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 0.9 | 94 | |
| 1 | 45 | |
| 1.1 | 6 | < 0.1% |
| 1.3 | 4 | < 0.1% |
| 1.4 | 3 | < 0.1% |
| 1.6 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 50 | 821 | |
| 49.9 | 37 | 0.2% |
| 49.7 | 39 | 0.2% |
| 49.6 | 36 | 0.2% |
| 49.4 | 28 | 0.2% |
| 49.3 | 35 | 0.2% |
| 49.1 | 25 | 0.1% |
| 49 | 91 | 0.5% |
| 48.9 | 1 | < 0.1% |
| 48.8 | 13 | 0.1% |
Cloud Cover
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14193 |
| Missing (%) | 79.9% |
| Memory size | 904.4 KiB |
| 0.0 | |
|---|---|
| 11.1 | |
| 13.0 | |
| 1.9 | 55 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.4055866 |
| Min length | 3 |
Characters and Unicode
| Total characters | 12192 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 11.1 |
|---|---|
| 2nd row | 13.0 |
| 3rd row | 13.0 |
| 4th row | 13.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 2073 | 11.7% |
| 11.1 | 740 | 4.2% |
| 13.0 | 712 | 4.0% |
| 1.9 | 55 | 0.3% |
| (Missing) | 14193 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 2073 | |
| 11.1 | 740 | 20.7% |
| 13.0 | 712 | 19.9% |
| 1.9 | 55 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4858 | |
| . | 3580 | |
| 1 | 2987 | |
| 3 | 712 | 5.8% |
| 9 | 55 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 8612 | |
| Other Punctuation | 3580 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4858 | |
| 1 | 2987 | |
| 3 | 712 | 8.3% |
| 9 | 55 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3580 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12192 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4858 | |
| . | 3580 | |
| 1 | 2987 | |
| 3 | 712 | 5.8% |
| 9 | 55 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12192 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4858 | |
| . | 3580 | |
| 1 | 2987 | |
| 3 | 712 | 5.8% |
| 9 | 55 | 0.5% |
Sea Level Pressure
Real number (ℝ)
| Distinct | 644 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 169 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1015.7098 |
| Minimum | 977.6 |
|---|---|
| Maximum | 1048.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | 977.6 |
|---|---|
| 5-th percentile | 997.9 |
| Q1 | 1009.6 |
| median | 1016.8 |
| Q3 | 1022.1 |
| 95-th percentile | 1030.8 |
| Maximum | 1048.2 |
| Range | 70.6 |
| Interquartile range (IQR) | 12.5 |
Descriptive statistics
| Standard deviation | 10.043681 |
|---|---|
| Coefficient of variation (CV) | 0.0098883378 |
| Kurtosis | 0.63333519 |
| Mean | 1015.7098 |
| Median Absolute Deviation (MAD) | 6.1 |
| Skewness | -0.43952496 |
| Sum | 17880554 |
| Variance | 100.87553 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1019.1 | 109 | 0.6% |
| 1019.9 | 108 | 0.6% |
| 1019.6 | 104 | 0.6% |
| 1017.8 | 101 | 0.6% |
| 1018.4 | 100 | 0.6% |
| 1021.4 | 99 | 0.6% |
| 1018.5 | 99 | 0.6% |
| 1018.9 | 98 | 0.6% |
| 1019.3 | 98 | 0.6% |
| 1019.2 | 97 | 0.5% |
| Other values (634) | 16591 | |
| (Missing) | 169 | 1.0% |
| Value | Count | Frequency (%) |
| 977.6 | 1 | < 0.1% |
| 977.7 | 2 | |
| 977.8 | 1 | < 0.1% |
| 977.9 | 1 | < 0.1% |
| 978.1 | 2 | |
| 978.3 | 1 | < 0.1% |
| 978.4 | 1 | < 0.1% |
| 978.5 | 1 | < 0.1% |
| 978.7 | 1 | < 0.1% |
| 978.9 | 3 |
| Value | Count | Frequency (%) |
| 1048.2 | 1 | < 0.1% |
| 1048.1 | 1 | < 0.1% |
| 1048 | 2 | |
| 1047.9 | 1 | < 0.1% |
| 1047.8 | 4 | |
| 1047.7 | 2 | |
| 1047.6 | 2 | |
| 1047.2 | 2 | |
| 1046.6 | 1 | < 0.1% |
| 1046.5 | 1 | < 0.1% |
y
Real number (ℝ)
| Distinct | 199 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0010127722 |
| Minimum | -100 |
|---|---|
| Maximum | 100 |
| Zeros | 8059 |
| Zeros (%) | 45.3% |
| Negative | 4846 |
| Negative (%) | 27.3% |
| Memory size | 277.7 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -17 |
| Q1 | -2 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 17 |
| Maximum | 100 |
| Range | 200 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 17.471133 |
|---|---|
| Coefficient of variation (CV) | 17250.803 |
| Kurtosis | 16.075643 |
| Mean | 0.0010127722 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.016380756 |
| Sum | 18 |
| Variance | 305.24049 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 8059 | |
| 3 | 598 | 3.4% |
| -3 | 592 | 3.3% |
| -4 | 529 | 3.0% |
| 4 | 503 | 2.8% |
| -5 | 472 | 2.7% |
| 2 | 469 | 2.6% |
| 5 | 460 | 2.6% |
| -2 | 437 | 2.5% |
| 6 | 373 | 2.1% |
| Other values (189) | 5281 |
| Value | Count | Frequency (%) |
| -100 | 88 | |
| -99 | 1 | < 0.1% |
| -98 | 3 | < 0.1% |
| -97 | 1 | < 0.1% |
| -96 | 1 | < 0.1% |
| -95 | 2 | < 0.1% |
| -94 | 1 | < 0.1% |
| -93 | 2 | < 0.1% |
| -92 | 2 | < 0.1% |
| -91 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 92 | |
| 99 | 2 | < 0.1% |
| 98 | 3 | < 0.1% |
| 96 | 3 | < 0.1% |
| 95 | 2 | < 0.1% |
| 93 | 2 | < 0.1% |
| 92 | 3 | < 0.1% |
| 91 | 3 | < 0.1% |
| 90 | 2 | < 0.1% |
| 89 | 2 | < 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.| Minimum Temperature | Maximum Temperature | Temperature | Dew Point | Relative Humidity | Wind Speed | Wind Direction | Wind Chill | Precipitation | Snow Depth | Visibility | Cloud Cover | Sea Level Pressure | y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020-10-01 00:00:00 | 12.3 | 12.3 | 12.3 | 11.1 | 92.43 | 8.8 | 120.0 | NaN | 0.0 | 0.0 | 17.7 | 11.1 | 1012.7 | 0 |
| 2020-10-01 01:00:00 | 11.8 | 11.8 | 11.8 | 10.6 | 92.79 | 10.1 | 106.0 | NaN | 0.0 | 0.0 | 15.1 | 13.0 | 1012.1 | 0 |
| 2020-10-01 02:00:00 | 11.2 | 11.2 | 11.2 | 10.2 | 93.60 | 8.8 | 120.0 | NaN | 0.0 | 0.0 | 14.7 | 13.0 | 1011.6 | 0 |
| 2020-10-01 03:00:00 | 10.5 | 10.5 | 10.5 | 9.6 | 93.64 | 6.0 | 110.0 | NaN | 0.0 | 0.0 | 14.1 | 13.0 | 1011.1 | -38 |
| 2020-10-01 04:00:00 | 10.3 | 10.3 | 10.3 | 9.4 | 94.15 | 8.6 | 127.0 | NaN | 0.0 | 0.0 | 14.0 | 0.0 | 1010.5 | 18 |
| 2020-10-01 05:00:00 | 10.2 | 10.2 | 10.2 | 9.4 | 94.54 | 11.0 | 111.0 | NaN | 0.0 | 0.0 | 14.4 | 0.0 | 1009.8 | -9 |
| 2020-10-01 06:00:00 | 9.8 | 9.8 | 9.8 | 9.0 | 94.88 | 10.0 | 116.0 | 8.4 | 0.0 | 0.0 | 12.9 | 1.9 | 1009.3 | 0 |
| 2020-10-01 07:00:00 | 9.7 | 9.7 | 9.7 | 8.8 | 93.99 | 14.8 | 100.0 | 7.6 | 0.0 | 0.0 | 12.0 | 0.0 | 1008.7 | 0 |
| 2020-10-01 08:00:00 | 9.7 | 9.7 | 9.7 | 8.7 | 93.58 | 12.6 | 107.0 | 7.9 | 0.0 | 0.0 | 12.1 | 11.1 | 1008.4 | -11 |
| 2020-10-01 09:00:00 | 10.7 | 10.7 | 10.7 | 9.3 | 91.16 | 13.5 | 109.0 | NaN | 0.0 | 0.0 | 12.1 | 0.0 | 1008.0 | -4 |
| Minimum Temperature | Maximum Temperature | Temperature | Dew Point | Relative Humidity | Wind Speed | Wind Direction | Wind Chill | Precipitation | Snow Depth | Visibility | Cloud Cover | Sea Level Pressure | y | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-10-09 15:00:00 | 15.0 | 15.0 | 15.0 | 7.1 | 59.04 | 12.3 | 200.0 | NaN | 0.0 | NaN | 49.0 | NaN | 1024.2 | -7 |
| 2022-10-09 16:00:00 | 15.3 | 15.3 | 15.3 | 7.1 | 58.12 | 12.9 | 179.0 | NaN | 0.0 | NaN | NaN | NaN | 1023.5 | 0 |
| 2022-10-09 17:00:00 | 14.8 | 14.8 | 14.8 | 6.6 | 57.78 | 16.1 | 171.0 | NaN | 0.0 | NaN | NaN | 11.1 | 1022.8 | 0 |
| 2022-10-09 18:00:00 | 13.7 | 13.7 | 13.7 | 7.2 | 64.59 | 14.4 | 150.0 | NaN | 0.0 | NaN | NaN | 0.0 | 1022.1 | -7 |
| 2022-10-09 19:00:00 | 11.3 | 11.3 | 11.3 | 7.2 | 75.66 | 12.0 | 139.0 | NaN | 0.0 | NaN | 28.0 | NaN | 1021.8 | -6 |
| 2022-10-09 20:00:00 | 9.8 | 9.8 | 9.8 | 7.0 | 82.65 | 8.3 | 103.0 | 8.8 | 0.0 | NaN | 40.6 | NaN | 1021.6 | 6 |
| 2022-10-09 21:00:00 | 8.9 | 8.9 | 8.9 | 6.7 | 86.24 | 7.9 | 103.0 | 7.7 | 0.0 | NaN | 46.9 | 13.0 | 1021.2 | 0 |
| 2022-10-09 22:00:00 | 9.2 | 9.2 | 9.2 | 6.5 | 83.40 | 11.4 | 120.0 | 7.5 | 0.0 | NaN | 42.9 | NaN | 1020.8 | 0 |
| 2022-10-09 23:00:00 | 9.3 | 9.3 | 9.3 | 6.4 | 81.75 | 14.3 | 131.0 | 7.2 | 0.0 | NaN | 46.0 | NaN | 1020.4 | 0 |
| 2022-10-10 00:00:00 | 9.0 | 9.0 | 9.0 | 6.0 | 81.39 | 15.8 | 147.0 | 6.6 | 0.0 | NaN | 49.0 | NaN | 1020.0 | 0 |
Most frequently occurring
| Minimum Temperature | Maximum Temperature | Temperature | Dew Point | Relative Humidity | Wind Speed | Wind Direction | Wind Chill | Precipitation | Snow Depth | Visibility | Cloud Cover | Sea Level Pressure | y | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.00 | NaN | NaN | NaN | NaN | 0 | 22 |
| 0 | -1.8 | -1.8 | -1.8 | -2.8 | 92.77 | 1.8 | 143.0 | NaN | 0.00 | NaN | 24.1 | 0.0 | 1032.6 | 0 | 2 |
| 1 | -1.3 | -1.3 | -1.3 | -1.9 | 95.23 | 5.1 | 95.0 | -3.1 | 0.00 | NaN | 8.3 | 0.0 | 1024.2 | -12 | 2 |
| 2 | 1.2 | 1.2 | 1.2 | -0.9 | 85.89 | NaN | NaN | NaN | 0.00 | 0.0 | NaN | 11.1 | NaN | -42 | 2 |
| 3 | 3.5 | 3.5 | 3.5 | 3.1 | 97.42 | 8.0 | 249.0 | 1.4 | 0.00 | 0.0 | 3.9 | NaN | 1006.5 | 28 | 2 |
| 4 | 4.1 | 4.1 | 4.1 | 3.1 | 93.56 | 11.2 | 151.0 | 1.3 | 0.00 | 0.0 | 25.6 | NaN | 1018.6 | 0 | 2 |
| 5 | 5.3 | 5.3 | 5.3 | 4.8 | 96.73 | 11.9 | 271.0 | 2.6 | 0.06 | NaN | 6.7 | NaN | 1031.3 | 0 | 2 |
| 6 | 5.4 | 5.4 | 5.4 | 2.7 | 82.59 | 9.9 | 260.0 | 3.2 | 0.05 | 0.0 | 35.1 | 13.0 | 1016.0 | -8 | 2 |
| 7 | 6.2 | 6.2 | 6.2 | 5.9 | 98.25 | 8.8 | 249.0 | 4.3 | 0.02 | 0.0 | 8.5 | NaN | 1026.2 | 30 | 2 |
| 8 | 6.6 | 6.6 | 6.6 | 1.3 | 68.99 | 2.0 | 82.0 | NaN | 0.00 | NaN | 14.9 | 0.0 | 1031.5 | 61 | 2 |